package cn.tedu.jdbc;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

public class JDBCDemo4 {
    public static void main(String[] args)  {
        try {
            Scanner scan=new Scanner(System.in);
            System.out.println("请输入你需要注销的用户名！");
            String userName=scan.nextLine();
            Connection connection=DBUtil.getConnextion("tedu");
            Statement statement = connection.createStatement();
            String sql="delete from userinfo where username="+userName+"";
            int i = statement.executeUpdate(sql);
            if (i>0){
                System.out.println("注销成功！");
            }else{
                System.out.println("用户名不存在，注销失败！");
            }
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }

    }
}
